USE Contacts
GO
--delete for Personality
IF ( OBJECT_ID('SP_DelPersonality') IS NOT NULL ) 
DROP PROCEDURE SP_DelPersonality
GO
CREATE PROCEDURE SP_DelPersonality
	@PersonalityID INT        
AS 
BEGIN 
SET NOCOUNT ON 
	DELETE dbo.Personality
    FROM   dbo.Personality
    WHERE  PersonalityID = @PersonalityID
END
GO

--execute SP_DelPersonality
--EXEC SP_DelPersonality
    --@PersonalityID=119   
--GO 

--delete for PlaceResidence
IF ( OBJECT_ID('SP_DelPlaceResidence') IS NOT NULL ) 
DROP PROCEDURE SP_DelPlaceResidence
GO
CREATE PROCEDURE SP_DelPlaceResidence
	@PlaceResidenceID INT        
AS 
BEGIN 
SET NOCOUNT ON 
	DELETE dbo.PlaceResidence
    FROM   dbo.PlaceResidence
    WHERE  PlaceResidenceID = @PlaceResidenceID
END
GO
--execute SP_DelPlaceResidence
--EXEC SP_DelPLaceResidence
     --@PlaceResidenceID  =  219   
--GO 

--delete for Position
IF ( OBJECT_ID('SP_DelPosition') IS NOT NULL ) 
DROP PROCEDURE SP_DelPosition
GO
CREATE PROCEDURE SP_DelPosition
	@PositionID INT        
AS 
BEGIN 
SET NOCOUNT ON 
	DELETE dbo.Position
    FROM   dbo.Position
    WHERE  PositionID = @PositionID
END
GO
--execute SP_DelPosition
--EXEC SP_DelPosition
     --@PositionID  =  314   
--GO 

--delete for Subdivision
IF ( OBJECT_ID('SP_DelSubdivision') IS NOT NULL ) 
DROP PROCEDURE SP_DelSubdivision
GO
CREATE PROCEDURE SP_DelSubdivision
	@SubdivisionID INT        
AS 
BEGIN 
SET NOCOUNT ON 
	DELETE dbo.Subdivision
    FROM   dbo.Subdivision
    WHERE  SubdivisionID = @SubdivisionID
END
GO
--execute SP_DelSubdivision
--EXEC SP_DelSubdivision
     --@SubdivisionID  =  406  
--GO 
